package com.topisv.tms.repository;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.topisv.tms.entity.YTOShortAddress;

public interface YTOShortAddressDao extends PagingAndSortingRepository<YTOShortAddress, Long>, JpaSpecificationExecutor<YTOShortAddress> {
	
	@Query("select t from YTOShortAddress t where t.provName = ?1 and t.cityName =?2 and t.distName =?3 and t.caCode =?4 ")
	YTOShortAddress findShortAddress(String provName, String cityName, String distName, String caCode);
}
